Overview

Brought to you by YData

Dataset statistics

Number of variables	41
Number of observations	79542
Missing cells	467279
Missing cells (%)	14.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.9 MiB
Average record size in memory	328.0 B

Variable types

Numeric	18
Text	12
Categorical	10
Unsupported	1

Alerts

`RUNDATE` has constant value "45401.0"	Constant
`ACQDATE` is highly overall correlated with `MAINOFF`	High correlation
`CBSA_DIV` is highly overall correlated with `CBSA_DIV_FLG` and 13 other fields	High correlation
`CBSA_DIV_FLG` is highly overall correlated with `CBSA_DIV` and 3 other fields	High correlation
`CBSA_DIV_NO` is highly overall correlated with `CBSA_DIV` and 8 other fields	High correlation
`CBSA_METRO` is highly overall correlated with `CBSA_DIV` and 6 other fields	High correlation
`CBSA_METRO_FLG` is highly overall correlated with `CBSA_DIV` and 6 other fields	High correlation
`CBSA_MICRO_FLG` is highly overall correlated with `CBSA_DIV` and 1 other fields	High correlation
`CBSA_NO` is highly overall correlated with `CBSA_DIV` and 5 other fields	High correlation
`CERT` is highly overall correlated with `FI_UNINUM`	High correlation
`CSA_FLG` is highly overall correlated with `CBSA_DIV` and 6 other fields	High correlation
`CSA_NO` is highly overall correlated with `CBSA_DIV` and 6 other fields	High correlation
`FI_UNINUM` is highly overall correlated with `CERT`	High correlation
`ID` is highly overall correlated with `UNINUM`	High correlation
`LATITUDE` is highly overall correlated with `CBSA_DIV` and 1 other fields	High correlation
`LONGITUDE` is highly overall correlated with `CBSA_DIV` and 2 other fields	High correlation
`MAINOFF` is highly overall correlated with `ACQDATE`	High correlation
`MDI_STATUS_DESC` is highly overall correlated with `OFFNUM`	High correlation
`OFFNUM` is highly overall correlated with `MDI_STATUS_DESC`	High correlation
`SERVTYPE` is highly overall correlated with `SERVTYPE_DESC`	High correlation
`SERVTYPE_DESC` is highly overall correlated with `SERVTYPE`	High correlation
`STCNTY` is highly overall correlated with `CBSA_DIV` and 3 other fields	High correlation
`UNINUM` is highly overall correlated with `ID`	High correlation
`X` is highly overall correlated with `CBSA_DIV` and 2 other fields	High correlation
`Y` is highly overall correlated with `CBSA_DIV` and 1 other fields	High correlation
`ZIP` is highly overall correlated with `CBSA_DIV` and 2 other fields	High correlation
`CBSA_MICRO_FLG` is highly imbalanced (52.8%)	Imbalance
`MAINOFF` is highly imbalanced (68.2%)	Imbalance
`SERVTYPE_DESC` is highly imbalanced (84.0%)	Imbalance
`ACQDATE` has 35323 (44.4%) missing values	Missing
`ADDRESS2` has 74814 (94.1%) missing values	Missing
`CBSA` has 20151 (25.3%) missing values	Missing
`CBSA_DIV` has 64418 (81.0%) missing values	Missing
`CBSA_DIV_NO` has 44268 (55.7%) missing values	Missing
`CBSA_METRO_NAME` has 28187 (35.4%) missing values	Missing
`CSA` has 31357 (39.4%) missing values	Missing
`CSA_NO` has 11207 (14.1%) missing values	Missing
`MDI_STATUS_CODE` has 77963 (98.0%) missing values	Missing
`MDI_STATUS_DESC` has 77963 (98.0%) missing values	Missing
`STALP` has 803 (1.0%) missing values	Missing
`STNAME` has 803 (1.0%) missing values	Missing
`OBJECTID` is uniformly distributed	Uniform
`OBJECTID` has unique values	Unique
`MDI_STATUS_CODE` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`X` has 5766 (7.2%) zeros	Zeros
`Y` has 5766 (7.2%) zeros	Zeros
`CBSA_DIV_NO` has 20151 (25.3%) zeros	Zeros
`CBSA_METRO` has 28187 (35.4%) zeros	Zeros
`CBSA_NO` has 20151 (25.3%) zeros	Zeros
`CSA_NO` has 20151 (25.3%) zeros	Zeros
`LATITUDE` has 5766 (7.2%) zeros	Zeros
`LONGITUDE` has 5766 (7.2%) zeros	Zeros
`OFFNUM` has 4577 (5.8%) zeros	Zeros
`STCNTY` has 803 (1.0%) zeros	Zeros

Reproduction

Analysis started	2025-06-03 16:10:50.070850
Analysis finished	2025-06-03 16:11:53.761757
Duration	1 minute and 3.69 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

X
Real number (ℝ)

High correlation Zeros

Distinct	72672
Distinct (%)	91.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-83.77563

Minimum	-166.24856
Maximum	163.01083
Zeros	5766
Zeros (%)	7.2%
Negative	73745
Negative (%)	92.7%
Memory size	621.6 KiB

Quantile statistics

Minimum	-166.24856
5-th percentile	-121.1656
Q1	-95.931608
median	-85.90069
Q3	-77.369721
95-th percentile	0
Maximum	163.01083
Range	329.25939
Interquartile range (IQR)	18.561887

Descriptive statistics

Standard deviation	27.774008
Coefficient of variation (CV)	-0.33152849
Kurtosis	5.2581445
Mean	-83.77563
Median Absolute Deviation (MAD)	9.340965
Skewness	1.8487707
Sum	-6663597.4
Variance	771.39555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5766	7.2%
-92.296582	11	< 0.1%
-112.0348945	9	< 0.1%
-66.059463	8	< 0.1%
-66.028075	8	< 0.1%
-93.27205096	6	< 0.1%
-98.495664	6	< 0.1%
-66.625687	6	< 0.1%
-96.80482098	6	< 0.1%
-85.49964299	5	< 0.1%
Other values (72662)	73710	92.7%

Value	Count	Frequency (%)
-166.2485582	1	< 0.1%
-165.4092107	1	< 0.1%
-165.4082716	1	< 0.1%
-162.592615	1	< 0.1%
-161.759877	1	< 0.1%
-161.7517956	1	< 0.1%
-159.72357	1	< 0.1%
-159.585582	1	< 0.1%
-159.476557	1	< 0.1%
-159.4735174	1	< 0.1%

Value	Count	Frequency (%)
163.01083	1	< 0.1%
158.2056	2	< 0.1%
151.84316	1	< 0.1%
151.84113	1	< 0.1%
145.760035	1	< 0.1%
145.7188384	2	< 0.1%
145.7172201	1	< 0.1%
145.6210308	1	< 0.1%
145.227823	1	< 0.1%
144.8843036	1	< 0.1%

Y
Real number (ℝ)

High correlation Zeros

Distinct	72636
Distinct (%)	91.3%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	35.080901

Minimum	-24.892786
Maximum	71.293282
Zeros	5766
Zeros (%)	7.2%
Negative	1
Negative (%)	< 0.1%
Memory size	621.6 KiB

Quantile statistics

Minimum	-24.892786
5-th percentile	0
Q1	33.442709
median	38.3252
Q3	41.248136
95-th percentile	44.986226
Maximum	71.293282
Range	96.186068
Interquartile range (IQR)	7.8054265

Descriptive statistics

Standard deviation	11.030896
Coefficient of variation (CV)	0.31444165
Kurtosis	4.6456093
Mean	35.080901
Median Absolute Deviation (MAD)	3.797494
Skewness	-2.2118584
Sum	2790369.9
Variance	121.68068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5766	7.2%
38.97345401	11	< 0.1%
33.50985786	9	< 0.1%
18.347484	8	< 0.1%
18.210621	8	< 0.1%
29.42687902	6	< 0.1%
32.86271798	6	< 0.1%
44.97609999	6	< 0.1%
18.103866	6	< 0.1%
43.08686201	5	< 0.1%
Other values (72626)	73710	92.7%

Value	Count	Frequency (%)
-24.89278582	1	< 0.1%
0	5766	7.2%
5.32492	1	< 0.1%
6.964	2	< 0.1%
7.34391	1	< 0.1%
7.34449	1	< 0.1%
7.44369	1	< 0.1%
7.44413	1	< 0.1%
13.39932359	1	< 0.1%
13.4378134	1	< 0.1%

Value	Count	Frequency (%)
71.293282	1	< 0.1%
66.892278	1	< 0.1%
66.56444	1	< 0.1%
64.85844899	1	< 0.1%
64.85833001	1	< 0.1%
64.855525	1	< 0.1%
64.85161401	1	< 0.1%
64.85093201	1	< 0.1%
64.848722	1	< 0.1%
64.846762	1	< 0.1%

OBJECTID
Real number (ℝ)

Uniform Unique

Distinct	79542
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39771.5

Minimum	1
Maximum	79542
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3978.05
Q1	19886.25
median	39771.5
Q3	59656.75
95-th percentile	75564.95
Maximum	79542
Range	79541
Interquartile range (IQR)	39770.5

Descriptive statistics

Standard deviation	22961.942
Coefficient of variation (CV)	0.57734664
Kurtosis	-1.2
Mean	39771.5
Median Absolute Deviation (MAD)	19885.5
Skewness	0
Sum	3.1635047 × 10⁹
Variance	5.2725078 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
79542	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
79526	1	< 0.1%
79525	1	< 0.1%
79524	1	< 0.1%
79523	1	< 0.1%
Other values (79532)	79532	> 99.9%

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
79542	1	< 0.1%
79541	1	< 0.1%
79540	1	< 0.1%
79539	1	< 0.1%
79538	1	< 0.1%
79537	1	< 0.1%
79536	1	< 0.1%
79535	1	< 0.1%
79534	1	< 0.1%
79533	1	< 0.1%

ACQDATE
Real number (ℝ)

High correlation Missing

Distinct	3688
Distinct (%)	8.3%
Missing	35323
Missing (%)	44.4%
Infinite	0
Infinite (%)	0.0%
Mean	39808.9

Minimum	25658
Maximum	45383
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	25658
5-th percentile	33798
Q1	37520.5
median	40039
Q3	42651
95-th percentile	44658
Maximum	45383
Range	19725
Interquartile range (IQR)	5130.5

Descriptive statistics

Standard deviation	3412.5757
Coefficient of variation (CV)	0.085723937
Kurtosis	-0.051323007
Mean	39808.9
Median Absolute Deviation (MAD)	2604
Skewness	-0.45438499
Sum	1.7603098 × 10⁹
Variance	11645673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40257	2063	2.6%
36364	1127	1.4%
38304	1123	1.4%
39716	1115	1.4%
40123	763	1.0%
38516	759	1.0%
43806	745	0.9%
37112	646	0.8%
40086	632	0.8%
44477	539	0.7%
Other values (3678)	34707	43.6%
(Missing)	35323	44.4%

Value	Count	Frequency (%)
25658	1	< 0.1%
25717	1	< 0.1%
25720	2	< 0.1%
25750	4	< 0.1%
25837	1	< 0.1%
25841	3	< 0.1%
25903	1	< 0.1%
25937	2	< 0.1%
25980	1	< 0.1%
26039	1	< 0.1%

Value	Count	Frequency (%)
45383	67	0.1%
45370	5	< 0.1%
45352	14	< 0.1%
45344	1	< 0.1%
45339	6	< 0.1%
45338	7	< 0.1%
45334	2	< 0.1%
45332	8	< 0.1%
45331	4	< 0.1%
45324	2	< 0.1%

ADDRESS
Text

Distinct	74294
Distinct (%)	93.4%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	73
Median length	65
Mean length	16.664089
Min length	3

Characters and Unicode

Total characters	1325495
Distinct characters	75
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	71617 ?
Unique (%)	90.0%

Sample

1st row	18001 Saint Rose Rd
2nd row	1350 12th St
3rd row	500 W Harrison St
4th row	891 Fairfax St
5th row	240 Salt Lick Rd

Value	Count	Frequency (%)
st	24493	8.4%
ave	12833	4.4%
rd	12463	4.3%
n	8040	2.8%
w	7978	2.7%
s	7933	2.7%
main	7559	2.6%
e	7123	2.4%
blvd	6243	2.1%
dr	4518	1.5%
Other values (24052)	192899	66.0%

Most occurring characters

Value	Count	Frequency (%)
	212625	16.0%
e	72758	5.5%
t	63820	4.8%
1	60682	4.6%
a	59845	4.5%
0	55690	4.2%
n	47693	3.6%
r	45183	3.4%
S	43994	3.3%
i	41606	3.1%
Other values (65)	621599	46.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1325495	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	212625	16.0%
e	72758	5.5%
t	63820	4.8%
1	60682	4.6%
a	59845	4.5%
0	55690	4.2%
n	47693	3.6%
r	45183	3.4%
S	43994	3.3%
i	41606	3.1%
Other values (65)	621599	46.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1325495	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	212625	16.0%
e	72758	5.5%
t	63820	4.8%
1	60682	4.6%
a	59845	4.5%
0	55690	4.2%
n	47693	3.6%
r	45183	3.4%
S	43994	3.3%
i	41606	3.1%
Other values (65)	621599	46.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1325495	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	212625	16.0%
e	72758	5.5%
t	63820	4.8%
1	60682	4.6%
a	59845	4.5%
0	55690	4.2%
n	47693	3.6%
r	45183	3.4%
S	43994	3.3%
i	41606	3.1%
Other values (65)	621599	46.9%

ADDRESS2
Text

Missing

Distinct	1302
Distinct (%)	27.5%
Missing	74814
Missing (%)	94.1%
Memory size	621.6 KiB

Length

Max length	51
Median length	7
Mean length	7.4426819
Min length	1

Characters and Unicode

Total characters	35189
Distinct characters	72
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	979 ?
Unique (%)	20.7%

Sample

1st row	Ste 104
2nd row	Ste 150
3rd row	Ste 300
4th row	Ste D
5th row	Ste 105

Value	Count	Frequency (%)
ste	3691	37.3%
100	858	8.7%
101	275	2.8%
suite	262	2.6%
a	260	2.6%
	223	2.3%
200	135	1.4%
unit	131	1.3%
1	127	1.3%
150	108	1.1%
Other values (1143)	3832	38.7%

Most occurring characters

Value	Count	Frequency (%)
	5180	14.7%
0	4420	12.6%
t	4343	12.3%
e	4331	12.3%
S	4064	11.5%
1	3452	9.8%
2	1036	2.9%
5	653	1.9%
i	604	1.7%
3	530	1.5%
Other values (62)	6576	18.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	35189	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5180	14.7%
0	4420	12.6%
t	4343	12.3%
e	4331	12.3%
S	4064	11.5%
1	3452	9.8%
2	1036	2.9%
5	653	1.9%
i	604	1.7%
3	530	1.5%
Other values (62)	6576	18.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	35189	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5180	14.7%
0	4420	12.6%
t	4343	12.3%
e	4331	12.3%
S	4064	11.5%
1	3452	9.8%
2	1036	2.9%
5	653	1.9%
i	604	1.7%
3	530	1.5%
Other values (62)	6576	18.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	35189	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5180	14.7%
0	4420	12.6%
t	4343	12.3%
e	4331	12.3%
S	4064	11.5%
1	3452	9.8%
2	1036	2.9%
5	653	1.9%
i	604	1.7%
3	530	1.5%
Other values (62)	6576	18.7%

BKCLASS
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

N	36757
NM	25032
SM	13308
SI	2446
SB	1842
Other values (3)	157

Length

Max length	7
Median length	2
Mean length	1.5379548
Min length	1

Characters and Unicode

Total characters	122332
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	SM
2nd row	SM
3rd row	SM
4th row	SM
5th row	NM

Common Values

Value	Count	Frequency (%)
N	36757	46.2%
NM	25032	31.5%
SM	13308	16.7%
SI	2446	3.1%
SB	1842	2.3%
SL	146	0.2%
OI	10	< 0.1%
BKCLASS	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	36757	46.2%
nm	25032	31.5%
sm	13308	16.7%
si	2446	3.1%
sb	1842	2.3%
sl	146	0.2%
oi	10	< 0.1%
bkclass	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	61789	50.5%
M	38340	31.3%
S	17744	14.5%
I	2456	2.0%
B	1843	1.5%
L	147	0.1%
O	10	< 0.1%
K	1	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	122332	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	61789	50.5%
M	38340	31.3%
S	17744	14.5%
I	2456	2.0%
B	1843	1.5%
L	147	0.1%
O	10	< 0.1%
K	1	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	122332	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	61789	50.5%
M	38340	31.3%
S	17744	14.5%
I	2456	2.0%
B	1843	1.5%
L	147	0.1%
O	10	< 0.1%
K	1	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	122332	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	61789	50.5%
M	38340	31.3%
S	17744	14.5%
I	2456	2.0%
B	1843	1.5%
L	147	0.1%
O	10	< 0.1%
K	1	< 0.1%
C	1	< 0.1%
A	1	< 0.1%

CBSA
Text

Missing

Distinct	823
Distinct (%)	1.4%
Missing	20151
Missing (%)	25.3%
Memory size	621.6 KiB

Length

Max length	45
Median length	34
Mean length	24.396255
Min length	4

Characters and Unicode

Total characters	1448918
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	St. Louis, MO-IL
2nd row	St. Louis, MO-IL
3rd row	St. Louis, MO-IL
4th row	St. Louis, MO-IL
5th row	St. Louis, MO-IL

Value	Count	Frequency (%)
city	6526	4.3%
tx	5732	3.8%
new	4694	3.1%
york-newark-jersey	4299	2.8%
ny-nj-pa	4299	2.8%
fl	4287	2.8%
oh	2334	1.5%
il-in-wi	2252	1.5%
chicago-naperville-elgin	2252	1.5%
pa	2151	1.4%
Other values (922)	113084	74.4%

Most occurring characters

Value	Count	Frequency (%)
a	94130	6.5%
-	92785	6.4%
	92519	6.4%
e	91360	6.3%
o	78746	5.4%
n	76660	5.3%
r	71410	4.9%
i	65973	4.6%
l	61528	4.2%
,	59390	4.1%
Other values (47)	664417	45.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1448918	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	94130	6.5%
-	92785	6.4%
	92519	6.4%
e	91360	6.3%
o	78746	5.4%
n	76660	5.3%
r	71410	4.9%
i	65973	4.6%
l	61528	4.2%
,	59390	4.1%
Other values (47)	664417	45.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1448918	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	94130	6.5%
-	92785	6.4%
	92519	6.4%
e	91360	6.3%
o	78746	5.4%
n	76660	5.3%
r	71410	4.9%
i	65973	4.6%
l	61528	4.2%
,	59390	4.1%
Other values (47)	664417	45.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1448918	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	94130	6.5%
-	92785	6.4%
	92519	6.4%
e	91360	6.3%
o	78746	5.4%
n	76660	5.3%
r	71410	4.9%
i	65973	4.6%
l	61528	4.2%
,	59390	4.1%
Other values (47)	664417	45.9%

CBSA_DIV
Categorical

High correlation Missing

Distinct	27
Distinct (%)	0.2%
Missing	64418
Missing (%)	81.0%
Memory size	621.6 KiB

New York-Jersey City-White Plains, NY-NJ	2392
Chicago-Naperville-Evanston, IL	1679
Dallas-Plano-Irving, TX	1129
Washington-Arlington-Alexandria, DC-VA-MD-WV	951
Cambridge-Newton-Framingham, MA	694
Other values (22)	8279

Length

Max length	49
Median length	38
Mean length	30.63343
Min length	8

Characters and Unicode

Total characters	463300
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Camden, NJ
2nd row	Camden, NJ
3rd row	Montgomery County-Bucks County-Chester County, PA
4th row	Camden, NJ
5th row	Chicago-Naperville-Evanston, IL

Common Values

Value	Count	Frequency (%)
New York-Jersey City-White Plains, NY-NJ	2392	3.0%
Chicago-Naperville-Evanston, IL	1679	2.1%
Dallas-Plano-Irving, TX	1129	1.4%
Washington-Arlington-Alexandria, DC-VA-MD-WV	951	1.2%
Cambridge-Newton-Framingham, MA	694	0.9%
Nassau County-Suffolk County, NY	657	0.8%
New Brunswick-Lakewood, NJ	648	0.8%
Seattle-Bellevue-Kent, WA	613	0.8%
Newark, NJ-PA	602	0.8%
Montgomery County-Bucks County-Chester County, PA	586	0.7%
Other values (17)	5173	6.5%
(Missing)	64418	81.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	3040	6.6%
york-jersey	2392	5.2%
city-white	2392	5.2%
plains	2392	5.2%
ny-nj	2392	5.2%
il	1863	4.1%
chicago-naperville-evanston	1679	3.7%
tx	1646	3.6%
county	1555	3.4%
fl	1350	3.0%
Other values (51)	25026	54.7%

Most occurring characters

Value	Count	Frequency (%)
e	30816	6.7%
	30603	6.6%
-	30147	6.5%
a	29318	6.3%
n	27591	6.0%
o	24817	5.4%
i	24424	5.3%
t	21093	4.6%
r	20954	4.5%
l	18764	4.1%
Other values (39)	204773	44.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	463300	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	30816	6.7%
	30603	6.6%
-	30147	6.5%
a	29318	6.3%
n	27591	6.0%
o	24817	5.4%
i	24424	5.3%
t	21093	4.6%
r	20954	4.5%
l	18764	4.1%
Other values (39)	204773	44.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	463300	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	30816	6.7%
	30603	6.6%
-	30147	6.5%
a	29318	6.3%
n	27591	6.0%
o	24817	5.4%
i	24424	5.3%
t	21093	4.6%
r	20954	4.5%
l	18764	4.1%
Other values (39)	204773	44.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	463300	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	30816	6.7%
	30603	6.6%
-	30147	6.5%
a	29318	6.3%
n	27591	6.0%
o	24817	5.4%
i	24424	5.3%
t	21093	4.6%
r	20954	4.5%
l	18764	4.1%
Other values (39)	204773	44.2%

CBSA_DIV_FLG
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

0.0	64418
1.0	15123

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	238623
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	64418	81.0%
1.0	15123	19.0%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	64418	81.0%
1.0	15123	19.0%

Most occurring characters

Value	Count	Frequency (%)
0	143959	60.3%
.	79541	33.3%
1	15123	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	143959	60.3%
.	79541	33.3%
1	15123	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	143959	60.3%
.	79541	33.3%
1	15123	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	143959	60.3%
.	79541	33.3%
1	15123	6.3%

CBSA_DIV_NO
Real number (ℝ)

High correlation Missing Zeros

Distinct	27
Distinct (%)	0.1%
Missing	44268
Missing (%)	55.7%
Infinite	0
Infinite (%)	0.0%
Mean	13093.458

Minimum	0
Maximum	48864
Zeros	20151
Zeros (%)	25.3%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	29404
95-th percentile	47664
Maximum	48864
Range	48864
Interquartile range (IQR)	29404

Descriptive statistics

Standard deviation	16743.616
Coefficient of variation (CV)	1.2787772
Kurtosis	-0.90882396
Mean	13093.458
Median Absolute Deviation (MAD)	0
Skewness	0.79692815
Sum	4.6185865 × 10⁸
Variance	2.8034868 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	20151	25.3%
35614	2392	3.0%
16984	1679	2.1%
19124	1129	1.4%
47894	951	1.2%
15764	694	0.9%
35004	657	0.8%
35154	648	0.8%
42644	613	0.8%
35084	602	0.8%
Other values (17)	5758	7.2%
(Missing)	44268	55.7%

Value	Count	Frequency (%)
0	20151	25.3%
14454	575	0.7%
15764	694	0.9%
15804	262	0.3%
16984	1679	2.1%
19124	1129	1.4%
19804	252	0.3%
20994	184	0.2%
22744	373	0.5%
23104	517	0.6%

Value	Count	Frequency (%)
48864	199	0.3%
48424	396	0.5%
47894	951	1.2%
47664	532	0.7%
45104	127	0.2%
42644	613	0.8%
40484	118	0.1%
37964	380	0.5%
35614	2392	3.0%
35154	648	0.8%

CBSA_METRO
Real number (ℝ)

High correlation Zeros

Distinct	330
Distinct (%)	0.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	19092.77

Minimum	0
Maximum	49660
Zeros	28187
Zeros (%)	35.4%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	17460
Q3	35620
95-th percentile	45500
Maximum	49660
Range	49660
Interquartile range (IQR)	35620

Descriptive statistics

Standard deviation	16729.762
Coefficient of variation (CV)	0.87623546
Kurtosis	-1.4394915
Mean	19092.77
Median Absolute Deviation (MAD)	17460
Skewness	0.15337292
Sum	1.518658 × 10⁹
Variance	2.7988494 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	28187	35.4%
35620	4299	5.4%
16980	2252	2.8%
19100	1646	2.1%
37980	1427	1.8%
14460	1387	1.7%
26420	1360	1.7%
33100	1350	1.7%
47900	1238	1.6%
12060	1071	1.3%
Other values (320)	35324	44.4%

Value	Count	Frequency (%)
0	28187	35.4%
10180	47	0.1%
10380	15	< 0.1%
10420	165	0.2%
10500	37	< 0.1%
10540	20	< 0.1%
10580	272	0.3%
10740	138	0.2%
10780	59	0.1%
10900	194	0.2%

Value	Count	Frequency (%)
49660	117	0.1%
49620	102	0.1%
49500	7	< 0.1%
49420	39	< 0.1%
49340	196	0.2%
49180	128	0.2%
49020	45	0.1%
48900	58	0.1%
48700	46	0.1%
48660	38	< 0.1%

CBSA_METRO_FLG
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

1.0	51354
0.0	28187

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	238623
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	51354	64.6%
0.0	28187	35.4%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	51354	64.6%
0.0	28187	35.4%

Most occurring characters

Value	Count	Frequency (%)
0	107728	45.1%
.	79541	33.3%
1	51354	21.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	107728	45.1%
.	79541	33.3%
1	51354	21.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	107728	45.1%
.	79541	33.3%
1	51354	21.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	107728	45.1%
.	79541	33.3%
1	51354	21.5%

CBSA_METRO_NAME
Text

Missing

Distinct	330
Distinct (%)	0.6%
Missing	28187
Missing (%)	35.4%
Memory size	621.6 KiB

Length

Max length	45
Median length	33
Mean length	26.136579
Min length	8

Characters and Unicode

Total characters	1342244
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	St. Louis, MO-IL
2nd row	St. Louis, MO-IL
3rd row	St. Louis, MO-IL
4th row	St. Louis, MO-IL
5th row	St. Louis, MO-IL

Value	Count	Frequency (%)
city	6268	4.7%
tx	5237	3.9%
new	4619	3.4%
york-newark-jersey	4299	3.2%
ny-nj-pa	4299	3.2%
fl	4213	3.1%
il-in-wi	2252	1.7%
chicago-naperville-elgin	2252	1.7%
pa	1815	1.4%
oh	1734	1.3%
Other values (460)	97386	72.5%

Most occurring characters

Value	Count	Frequency (%)
-	91806	6.8%
a	88095	6.6%
e	84320	6.3%
	83019	6.2%
o	73512	5.5%
n	70904	5.3%
r	66684	5.0%
i	61287	4.6%
l	56478	4.2%
t	54828	4.1%
Other values (45)	611311	45.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1342244	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	91806	6.8%
a	88095	6.6%
e	84320	6.3%
	83019	6.2%
o	73512	5.5%
n	70904	5.3%
r	66684	5.0%
i	61287	4.6%
l	56478	4.2%
t	54828	4.1%
Other values (45)	611311	45.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1342244	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	91806	6.8%
a	88095	6.6%
e	84320	6.3%
	83019	6.2%
o	73512	5.5%
n	70904	5.3%
r	66684	5.0%
i	61287	4.6%
l	56478	4.2%
t	54828	4.1%
Other values (45)	611311	45.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1342244	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	91806	6.8%
a	88095	6.6%
e	84320	6.3%
	83019	6.2%
o	73512	5.5%
n	70904	5.3%
r	66684	5.0%
i	61287	4.6%
l	56478	4.2%
t	54828	4.1%
Other values (45)	611311	45.5%

CBSA_MICRO_FLG
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

0.0	71505
1.0	8036

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	238623
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	71505	89.9%
1.0	8036	10.1%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	71505	89.9%
1.0	8036	10.1%

Most occurring characters

Value	Count	Frequency (%)
0	151046	63.3%
.	79541	33.3%
1	8036	3.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	151046	63.3%
.	79541	33.3%
1	8036	3.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	151046	63.3%
.	79541	33.3%
1	8036	3.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	151046	63.3%
.	79541	33.3%
1	8036	3.4%

CBSA_NO
Real number (ℝ)

High correlation Zeros

Distinct	823
Distinct (%)	1.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	22142.574

Minimum	0
Maximum	49820
Zeros	20151
Zeros (%)	25.3%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	22800
Q3	35620
95-th percentile	46140
Maximum	49820
Range	49820
Interquartile range (IQR)	35620

Descriptive statistics

Standard deviation	16085.458
Coefficient of variation (CV)	0.72644931
Kurtosis	-1.3133933
Mean	22142.574
Median Absolute Deviation (MAD)	12820
Skewness	-0.1023125
Sum	1.7612425 × 10⁹
Variance	2.5874196 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20151	25.3%
35620	4299	5.4%
16980	2252	2.8%
19100	1646	2.1%
37980	1427	1.8%
14460	1387	1.7%
26420	1360	1.7%
33100	1350	1.7%
47900	1238	1.6%
12060	1071	1.3%
Other values (813)	43360	54.5%

Value	Count	Frequency (%)
0	20151	25.3%
10100	20	< 0.1%
10140	23	< 0.1%
10180	47	0.1%
10220	15	< 0.1%
10300	18	< 0.1%
10380	15	< 0.1%
10420	165	0.2%
10460	13	< 0.1%
10500	37	< 0.1%

Value	Count	Frequency (%)
49820	3	< 0.1%
49780	27	< 0.1%
49660	117	0.1%
49620	102	0.1%
49500	7	< 0.1%
49460	9	< 0.1%
49420	39	< 0.1%
49380	13	< 0.1%
49340	196	0.2%
49300	43	0.1%

CERT
Real number (ℝ)

High correlation

Distinct	4577
Distinct (%)	5.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	14436.781

Minimum	14
Maximum	91325
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	14
5-th percentile	628
Q1	3511
median	9712
Q3	18609
95-th percentile	57415
Maximum	91325
Range	91311
Interquartile range (IQR)	15098

Descriptive statistics

Standard deviation	14942.208
Coefficient of variation (CV)	1.0350097
Kurtosis	4.600371
Mean	14436.781
Median Absolute Deviation (MAD)	6427
Skewness	1.9460052
Sum	1.148316 × 10⁹
Variance	2.2326958 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
628	5141	6.5%
3511	4366	5.5%
3510	3977	5.0%
6384	2375	3.0%
6548	2299	2.9%
9846	2005	2.5%
12368	1282	1.6%
18409	1184	1.5%
6560	1177	1.5%
6672	1079	1.4%
Other values (4567)	54656	68.7%

Value	Count	Frequency (%)
14	3	< 0.1%
35	8	< 0.1%
39	8	< 0.1%
41	4	< 0.1%
49	1	< 0.1%
50	7	< 0.1%
51	5	< 0.1%
52	1	< 0.1%
54	5	< 0.1%
58	21	< 0.1%

Value	Count	Frequency (%)
91325	15	< 0.1%
91280	5	< 0.1%
91005	6	< 0.1%
90384	4	< 0.1%
90311	7	< 0.1%
90308	6	< 0.1%
90303	13	< 0.1%
90300	27	< 0.1%
90297	7	< 0.1%
90291	9	< 0.1%

CITY
Text

Distinct	10354
Distinct (%)	13.0%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	28
Median length	25
Mean length	8.8637324
Min length	3

Characters and Unicode

Total characters	705039
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3716 ?
Unique (%)	4.7%

Sample

1st row	Breese
2nd row	Carlyle
3rd row	Aviston
4th row	Carlyle
5th row	Saint Peters

Value	Count	Frequency (%)
city	2141	2.1%
new	1217	1.2%
san	1168	1.2%
beach	946	0.9%
park	786	0.8%
fort	755	0.7%
lake	722	0.7%
york	663	0.7%
west	660	0.7%
saint	643	0.6%
Other values (8480)	91511	90.4%

Most occurring characters

Value	Count	Frequency (%)
e	64102	9.1%
a	60487	8.6%
o	54155	7.7%
n	53613	7.6%
l	47976	6.8%
i	44204	6.3%
r	44143	6.3%
t	37189	5.3%
s	30731	4.4%
	21671	3.1%
Other values (55)	246768	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	705039	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	64102	9.1%
a	60487	8.6%
o	54155	7.7%
n	53613	7.6%
l	47976	6.8%
i	44204	6.3%
r	44143	6.3%
t	37189	5.3%
s	30731	4.4%
	21671	3.1%
Other values (55)	246768	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	705039	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	64102	9.1%
a	60487	8.6%
o	54155	7.7%
n	53613	7.6%
l	47976	6.8%
i	44204	6.3%
r	44143	6.3%
t	37189	5.3%
s	30731	4.4%
	21671	3.1%
Other values (55)	246768	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	705039	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	64102	9.1%
a	60487	8.6%
o	54155	7.7%
n	53613	7.6%
l	47976	6.8%
i	44204	6.3%
r	44143	6.3%
t	37189	5.3%
s	30731	4.4%
	21671	3.1%
Other values (55)	246768	35.0%

COUNTY
Text

Distinct	1914
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	21
Median length	19
Mean length	7.4486058
Min length	3

Characters and Unicode

Total characters	592477
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	135 ?
Unique (%)	0.2%

Sample

1st row	Clinton
2nd row	Clinton
3rd row	Clinton
4th row	Clinton
5th row	St. Charles

Value	Count	Frequency (%)
los	1471	1.6%
angeles	1466	1.6%
san	1355	1.5%
cook	1162	1.3%
st	1083	1.2%
new	1067	1.2%
orange	977	1.1%
montgomery	973	1.1%
jefferson	947	1.0%
harris	888	1.0%
Other values (1927)	78951	87.4%

Most occurring characters

Value	Count	Frequency (%)
a	60033	10.1%
e	55815	9.4%
n	46011	7.8%
o	45147	7.6%
r	38114	6.4%
l	33275	5.6%
i	32248	5.4%
s	28551	4.8%
t	24319	4.1%
u	15271	2.6%
Other values (47)	213693	36.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	592477	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	60033	10.1%
e	55815	9.4%
n	46011	7.8%
o	45147	7.6%
r	38114	6.4%
l	33275	5.6%
i	32248	5.4%
s	28551	4.8%
t	24319	4.1%
u	15271	2.6%
Other values (47)	213693	36.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	592477	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	60033	10.1%
e	55815	9.4%
n	46011	7.8%
o	45147	7.6%
r	38114	6.4%
l	33275	5.6%
i	32248	5.4%
s	28551	4.8%
t	24319	4.1%
u	15271	2.6%
Other values (47)	213693	36.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	592477	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	60033	10.1%
e	55815	9.4%
n	46011	7.8%
o	45147	7.6%
r	38114	6.4%
l	33275	5.6%
i	32248	5.4%
s	28551	4.8%
t	24319	4.1%
u	15271	2.6%
Other values (47)	213693	36.1%

CSA
Text

Missing

Distinct	155
Distinct (%)	0.3%
Missing	31357
Missing (%)	39.4%
Memory size	621.6 KiB

Length

Max length	58
Median length	41
Mean length	31.908519
Min length	3

Characters and Unicode

Total characters	1537512
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	St. Louis-St. Charles-Farmington, MO-IL
2nd row	St. Louis-St. Charles-Farmington, MO-IL
3rd row	St. Louis-St. Charles-Farmington, MO-IL
4th row	St. Louis-St. Charles-Farmington, MO-IL
5th row	St. Louis-St. Charles-Farmington, MO-IL

Value	Count	Frequency (%)
new	5058	3.9%
ny-nj-ct-pa	4661	3.6%
york-newark	4661	3.6%
fl	2896	2.2%
tx	2639	2.0%
il-in-wi	2386	1.8%
chicago-naperville	2386	1.8%
st	2382	1.8%
boston-worcester-providence	2212	1.7%
ma-ri-nh-ct	2212	1.7%
Other values (294)	99105	75.9%

Most occurring characters

Value	Count	Frequency (%)
-	132236	8.6%
a	99827	6.5%
e	99057	6.4%
o	84261	5.5%
n	83220	5.4%
	82413	5.4%
r	76193	5.0%
i	66479	4.3%
t	64955	4.2%
l	63105	4.1%
Other values (46)	685766	44.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1537512	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	132236	8.6%
a	99827	6.5%
e	99057	6.4%
o	84261	5.5%
n	83220	5.4%
	82413	5.4%
r	76193	5.0%
i	66479	4.3%
t	64955	4.2%
l	63105	4.1%
Other values (46)	685766	44.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1537512	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	132236	8.6%
a	99827	6.5%
e	99057	6.4%
o	84261	5.5%
n	83220	5.4%
	82413	5.4%
r	76193	5.0%
i	66479	4.3%
t	64955	4.2%
l	63105	4.1%
Other values (46)	685766	44.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1537512	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	132236	8.6%
a	99827	6.5%
e	99057	6.4%
o	84261	5.5%
n	83220	5.4%
	82413	5.4%
r	76193	5.0%
i	66479	4.3%
t	64955	4.2%
l	63105	4.1%
Other values (46)	685766	44.6%

CSA_FLG
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

1.0	48184
0.0	31357

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	238623
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	48184	60.6%
0.0	31357	39.4%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	48184	60.6%
0.0	31357	39.4%

Most occurring characters

Value	Count	Frequency (%)
0	110898	46.5%
.	79541	33.3%
1	48184	20.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	110898	46.5%
.	79541	33.3%
1	48184	20.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	110898	46.5%
.	79541	33.3%
1	48184	20.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	110898	46.5%
.	79541	33.3%
1	48184	20.2%

CSA_NO
Real number (ℝ)

High correlation Missing Zeros

Distinct	155
Distinct (%)	0.2%
Missing	11207
Missing (%)	14.1%
Infinite	0
Infinite (%)	0.0%
Mean	232.08586

Minimum	0
Maximum	566
Zeros	20151
Zeros (%)	25.3%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	212
Q3	408
95-th percentile	534
Maximum	566
Range	566
Interquartile range (IQR)	408

Descriptive statistics

Standard deviation	185.23903
Coefficient of variation (CV)	0.79814872
Kurtosis	-1.3672762
Mean	232.08586
Median Absolute Deviation (MAD)	196
Skewness	0.055114421
Sum	15859587
Variance	34313.498
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20151	25.3%
408	4661	5.9%
176	2386	3.0%
148	2212	2.8%
548	1965	2.5%
206	1797	2.3%
428	1661	2.1%
370	1515	1.9%
288	1407	1.8%
122	1232	1.5%
Other values (145)	29348	36.9%
(Missing)	11207	14.1%

Value	Count	Frequency (%)
0	20151	25.3%
104	357	0.4%
106	189	0.2%
107	61	0.1%
108	81	0.1%
118	81	0.1%
120	109	0.1%
122	1232	1.5%
140	50	0.1%
144	49	0.1%

Value	Count	Frequency (%)
566	149	0.2%
558	58	0.1%
556	236	0.3%
554	102	0.1%
548	1965	2.5%
545	272	0.3%
544	34	< 0.1%
540	101	0.1%
539	91	0.1%
538	311	0.4%

ESTYMD
Text

Distinct	26127
Distinct (%)	32.8%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	10
Median length	10
Mean length	9.3876443
Min length	1

Characters and Unicode

Total characters	746712
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13497 ?
Unique (%)	17.0%

Sample

1st row	30964
2nd row	25373
3rd row	39104
4th row	01/01/1878
5th row	38383

Value	Count	Frequency (%)
01/01/1889	312	0.4%
01/01/1890	249	0.3%
01/01/1934	233	0.3%
01/01/1919	232	0.3%
01/01/1923	232	0.3%
01/01/1887	205	0.3%
01/01/1921	159	0.2%
10/23/1989	156	0.2%
06/30/1987	153	0.2%
06/30/1985	148	0.2%
Other values (26117)	77463	97.4%

Most occurring characters

Value	Count	Frequency (%)
0	152117	20.4%
/	139934	18.7%
1	134962	18.1%
2	81802	11.0%
9	69713	9.3%
8	33477	4.5%
3	31566	4.2%
7	27990	3.7%
6	26864	3.6%
5	24649	3.3%
Other values (7)	23638	3.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	746712	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	152117	20.4%
/	139934	18.7%
1	134962	18.1%
2	81802	11.0%
9	69713	9.3%
8	33477	4.5%
3	31566	4.2%
7	27990	3.7%
6	26864	3.6%
5	24649	3.3%
Other values (7)	23638	3.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	746712	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	152117	20.4%
/	139934	18.7%
1	134962	18.1%
2	81802	11.0%
9	69713	9.3%
8	33477	4.5%
3	31566	4.2%
7	27990	3.7%
6	26864	3.6%
5	24649	3.3%
Other values (7)	23638	3.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	746712	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	152117	20.4%
/	139934	18.7%
1	134962	18.1%
2	81802	11.0%
9	69713	9.3%
8	33477	4.5%
3	31566	4.2%
7	27990	3.7%
6	26864	3.6%
5	24649	3.3%
Other values (7)	23638	3.2%

FI_UNINUM
Real number (ℝ)

High correlation

Distinct	4577
Distinct (%)	5.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	32378.417

Minimum	6
Maximum	650140
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	6
5-th percentile	417
Q1	2239
median	6212
Q3	12494
95-th percentile	82012
Maximum	650140
Range	650134
Interquartile range (IQR)	10255

Descriptive statistics

Standard deviation	94083.084
Coefficient of variation (CV)	2.9057345
Kurtosis	15.521056
Mean	32378.417
Median Absolute Deviation (MAD)	4088
Skewness	4.0901547
Sum	2.5754117 × 10⁹
Variance	8.8516266 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
417	5141	6.5%
2239	4366	5.5%
2238	3977	5.0%
4287	2375	3.0%
4383	2299	2.9%
6300	2005	2.5%
7866	1282	1.6%
12315	1184	1.5%
4390	1177	1.5%
4470	1079	1.4%
Other values (4567)	54656	68.7%

Value	Count	Frequency (%)
6	3	< 0.1%
17	8	< 0.1%
21	8	< 0.1%
23	4	< 0.1%
30	1	< 0.1%
31	7	< 0.1%
32	5	< 0.1%
33	1	< 0.1%
35	5	< 0.1%
39	21	< 0.1%

Value	Count	Frequency (%)
650140	1	< 0.1%
649963	1	< 0.1%
647694	1	< 0.1%
645970	1	< 0.1%
644984	4	< 0.1%
641772	2	< 0.1%
641744	1	< 0.1%
641636	1	< 0.1%
640962	1	< 0.1%
640695	1	< 0.1%

ID
Real number (ℝ)

High correlation

Distinct	79541
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	305329.74

Minimum	3
Maximum	663907
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	3
5-th percentile	6214
Q1	198678
median	263437
Q3	464262
95-th percentile	627297
Maximum	663907
Range	663904
Interquartile range (IQR)	265584

Descriptive statistics

Standard deviation	191723.6
Coefficient of variation (CV)	0.62792309
Kurtosis	-0.95377428
Mean	305329.74
Median Absolute Deviation (MAD)	168927
Skewness	0.08674046
Sum	2.4286233 × 10¹⁰
Variance	3.6757937 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
629595	1	< 0.1%
223055	1	< 0.1%
232078	1	< 0.1%
466427	1	< 0.1%
9231	1	< 0.1%
429739	1	< 0.1%
641411	1	< 0.1%
641392	1	< 0.1%
632193	1	< 0.1%
621883	1	< 0.1%
Other values (79531)	79531	> 99.9%

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%

Value	Count	Frequency (%)
663907	1	< 0.1%
663906	1	< 0.1%
663905	1	< 0.1%
663904	1	< 0.1%
663898	1	< 0.1%
663897	1	< 0.1%
663896	1	< 0.1%
663886	1	< 0.1%
663885	1	< 0.1%
663876	1	< 0.1%

LATITUDE
Real number (ℝ)

High correlation Zeros

Distinct	72751
Distinct (%)	91.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	35.080901

Minimum	-24.892786
Maximum	71.293282
Zeros	5766
Zeros (%)	7.2%
Negative	1
Negative (%)	< 0.1%
Memory size	621.6 KiB

Quantile statistics

Minimum	-24.892786
5-th percentile	0
Q1	33.442709
median	38.3252
Q3	41.248136
95-th percentile	44.986226
Maximum	71.293282
Range	96.186068
Interquartile range (IQR)	7.8054265

Descriptive statistics

Standard deviation	11.030896
Coefficient of variation (CV)	0.31444165
Kurtosis	4.6456093
Mean	35.080901
Median Absolute Deviation (MAD)	3.797494
Skewness	-2.2118584
Sum	2790369.9
Variance	121.68068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5766	7.2%
38.97345401	11	< 0.1%
33.50985786	9	< 0.1%
18.210621	8	< 0.1%
18.347484	8	< 0.1%
18.103866	6	< 0.1%
29.42687902	6	< 0.1%
44.97609999	6	< 0.1%
43.08686201	5	< 0.1%
42.934779	5	< 0.1%
Other values (72741)	73711	92.7%

Value	Count	Frequency (%)
-24.89278582	1	< 0.1%
0	5766	7.2%
5.32492	1	< 0.1%
6.964	2	< 0.1%
7.34391	1	< 0.1%
7.34449	1	< 0.1%
7.44369	1	< 0.1%
7.44413	1	< 0.1%
13.39932359	1	< 0.1%
13.4378134	1	< 0.1%

Value	Count	Frequency (%)
71.293282	1	< 0.1%
66.892278	1	< 0.1%
66.56444	1	< 0.1%
64.85844899	1	< 0.1%
64.85833001	1	< 0.1%
64.855525	1	< 0.1%
64.85161401	1	< 0.1%
64.85093201	1	< 0.1%
64.848722	1	< 0.1%
64.846762	1	< 0.1%

LONGITUDE
Real number (ℝ)

High correlation Zeros

Distinct	72774
Distinct (%)	91.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-83.77563

Minimum	-166.24856
Maximum	163.01083
Zeros	5766
Zeros (%)	7.2%
Negative	73745
Negative (%)	92.7%
Memory size	621.6 KiB

Quantile statistics

Minimum	-166.24856
5-th percentile	-121.1656
Q1	-95.931608
median	-85.90069
Q3	-77.369721
95-th percentile	0
Maximum	163.01083
Range	329.25939
Interquartile range (IQR)	18.561887

Descriptive statistics

Standard deviation	27.774008
Coefficient of variation (CV)	-0.33152849
Kurtosis	5.2581445
Mean	-83.77563
Median Absolute Deviation (MAD)	9.340965
Skewness	1.8487707
Sum	-6663597.4
Variance	771.39555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5766	7.2%
-92.296582	11	< 0.1%
-112.0348945	9	< 0.1%
-66.028075	8	< 0.1%
-66.059463	8	< 0.1%
-98.495664	6	< 0.1%
-66.625687	6	< 0.1%
-93.27205096	5	< 0.1%
-85.51531002	5	< 0.1%
-85.49964299	5	< 0.1%
Other values (72764)	73712	92.7%

Value	Count	Frequency (%)
-166.2485582	1	< 0.1%
-165.4092107	1	< 0.1%
-165.4082716	1	< 0.1%
-162.592615	1	< 0.1%
-161.759877	1	< 0.1%
-161.7517956	1	< 0.1%
-159.72357	1	< 0.1%
-159.585582	1	< 0.1%
-159.476557	1	< 0.1%
-159.4735174	1	< 0.1%

Value	Count	Frequency (%)
163.01083	1	< 0.1%
158.2056	2	< 0.1%
151.84316	1	< 0.1%
151.84113	1	< 0.1%
145.760035	1	< 0.1%
145.7188384	2	< 0.1%
145.7172201	1	< 0.1%
145.6210308	1	< 0.1%
145.227823	1	< 0.1%
144.8843036	1	< 0.1%

MAINOFF
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

0.0	74964
1.0	4577

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	238623
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
0.0	74964	94.2%
1.0	4577	5.8%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	74964	94.2%
1.0	4577	5.8%

Most occurring characters

Value	Count	Frequency (%)
0	154505	64.7%
.	79541	33.3%
1	4577	1.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	154505	64.7%
.	79541	33.3%
1	4577	1.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	154505	64.7%
.	79541	33.3%
1	4577	1.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	238623	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	154505	64.7%
.	79541	33.3%
1	4577	1.9%

MDI_STATUS_CODE
Unsupported

Missing Rejected Unsupported

Missing	77963
Missing (%)	98.0%
Memory size	621.6 KiB

MDI_STATUS_DESC
Categorical

High correlation Missing

Distinct	11
Distinct (%)	0.7%
Missing	77963
Missing (%)	98.0%
Memory size	621.6 KiB

MINORITY BOARD AND SERVING HISPANIC COMMUNITY	510
ASIAN OR PACIFIC ISLANDER AMERICANS	409
MINORITY BOARD AND SERVING ASIAN OR PACIFIC ISLANDER COMMUNITY	310
HISPANIC AMERICAN	134
NATIVE AMERICAN OR NATIVE ALASKAN AMERICAN	105
Other values (6)	111

Length

Max length	62
Median length	53
Mean length	41.644712
Min length	4

Characters and Unicode

Total characters	65757
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	ASIAN OR PACIFIC ISLANDER AMERICANS
2nd row	ASIAN OR PACIFIC ISLANDER AMERICANS
3rd row	ASIAN OR PACIFIC ISLANDER AMERICANS
4th row	ASIAN OR PACIFIC ISLANDER AMERICANS
5th row	ASIAN OR PACIFIC ISLANDER AMERICANS

Common Values

Value	Count	Frequency (%)
MINORITY BOARD AND SERVING HISPANIC COMMUNITY	510	0.6%
ASIAN OR PACIFIC ISLANDER AMERICANS	409	0.5%
MINORITY BOARD AND SERVING ASIAN OR PACIFIC ISLANDER COMMUNITY	310	0.4%
HISPANIC AMERICAN	134	0.2%
NATIVE AMERICAN OR NATIVE ALASKAN AMERICAN	105	0.1%
AFRICAN AMERICAN	79	0.1%
MINORITY BOARD AND SERVING AFRICAN AMERICAN COMMUNITY	21	< 0.1%
NONE	6	< 0.1%
MINORITY BOARD AND SERVING MULTI-RACIAL COMMUNITY	3	< 0.1%
MDI_STATUS_DESC	1	< 0.1%
(Missing)	77963	98.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
minority	844	9.2%
board	844	9.2%
and	844	9.2%
serving	844	9.2%
community	844	9.2%
or	824	9.0%
pacific	719	7.9%
asian	719	7.9%
islander	719	7.9%
hispanic	644	7.1%
Other values (8)	1280	14.0%

Most occurring characters

Value	Count	Frequency (%)
I	8713	13.3%
A	7650	11.6%
	7546	11.5%
N	6739	10.2%
R	5033	7.7%
C	3885	5.9%
S	3443	5.2%
M	3391	5.2%
O	3362	5.1%
E	2634	4.0%
Other values (14)	13361	20.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65757	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	8713	13.3%
A	7650	11.6%
	7546	11.5%
N	6739	10.2%
R	5033	7.7%
C	3885	5.9%
S	3443	5.2%
M	3391	5.2%
O	3362	5.1%
E	2634	4.0%
Other values (14)	13361	20.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65757	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	8713	13.3%
A	7650	11.6%
	7546	11.5%
N	6739	10.2%
R	5033	7.7%
C	3885	5.9%
S	3443	5.2%
M	3391	5.2%
O	3362	5.1%
E	2634	4.0%
Other values (14)	13361	20.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65757	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	8713	13.3%
A	7650	11.6%
	7546	11.5%
N	6739	10.2%
R	5033	7.7%
C	3885	5.9%
S	3443	5.2%
M	3391	5.2%
O	3362	5.1%
E	2634	4.0%
Other values (14)	13361	20.3%

NAME
Text

Distinct	4016
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	68
Median length	56
Mean length	25.620867
Min length	3

Characters and Unicode

Total characters	2037935
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	704 ?
Unique (%)	0.9%

Sample

1st row	1NB Bank
2nd row	1NB Bank
3rd row	1NB Bank
4th row	1NB Bank
5th row	1st Advantage Bank

Value	Count	Frequency (%)
bank	72321	24.8%
national	35733	12.2%
association	28951	9.9%
of	9981	3.4%
first	6776	2.3%
trust	6207	2.1%
the	5258	1.8%
chase	5142	1.8%
jpmorgan	5142	1.8%
wells	4375	1.5%
Other values (2681)	112192	38.4%

Most occurring characters

Value	Count	Frequency (%)
a	247526	12.1%
	212925	10.4%
n	202241	9.9%
i	151721	7.4%
o	150523	7.4%
t	125249	6.1%
s	112556	5.5%
B	81439	4.0%
k	78621	3.9%
e	72465	3.6%
Other values (61)	602669	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2037935	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	247526	12.1%
	212925	10.4%
n	202241	9.9%
i	151721	7.4%
o	150523	7.4%
t	125249	6.1%
s	112556	5.5%
B	81439	4.0%
k	78621	3.9%
e	72465	3.6%
Other values (61)	602669	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2037935	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	247526	12.1%
	212925	10.4%
n	202241	9.9%
i	151721	7.4%
o	150523	7.4%
t	125249	6.1%
s	112556	5.5%
B	81439	4.0%
k	78621	3.9%
e	72465	3.6%
Other values (61)	602669	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2037935	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	247526	12.1%
	212925	10.4%
n	202241	9.9%
i	151721	7.4%
o	150523	7.4%
t	125249	6.1%
s	112556	5.5%
B	81439	4.0%
k	78621	3.9%
e	72465	3.6%
Other values (61)	602669	29.6%

OFFNAME
Text

Distinct	51238
Distinct (%)	64.4%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

Length

Max length	93
Median length	69
Mean length	20.07865
Min length	3

Characters and Unicode

Total characters	1597096
Distinct characters	81
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	42175 ?
Unique (%)	53.0%

Sample

1st row	ST. ROSE FACILITY BRANCH
2nd row	1350 12TH STREET FACILITY
3rd row	AVISTON BRANCH
4th row	1NB Bank
5th row	1st Advantage Bank

Value	Count	Frequency (%)
branch	69727	29.2%
bank	6361	2.7%
	3614	1.5%
center	2868	1.2%
street	2211	0.9%
main	2039	0.9%
and	1917	0.8%
office	1871	0.8%
west	1787	0.7%
banking	1755	0.7%
Other values (18828)	144855	60.6%

Most occurring characters

Value	Count	Frequency (%)
	160059	10.0%
A	135262	8.5%
N	127057	8.0%
R	120499	7.5%
B	93985	5.9%
C	91654	5.7%
H	84757	5.3%
E	82327	5.2%
O	57740	3.6%
T	53707	3.4%
Other values (71)	590049	36.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1597096	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	160059	10.0%
A	135262	8.5%
N	127057	8.0%
R	120499	7.5%
B	93985	5.9%
C	91654	5.7%
H	84757	5.3%
E	82327	5.2%
O	57740	3.6%
T	53707	3.4%
Other values (71)	590049	36.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1597096	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	160059	10.0%
A	135262	8.5%
N	127057	8.0%
R	120499	7.5%
B	93985	5.9%
C	91654	5.7%
H	84757	5.3%
E	82327	5.2%
O	57740	3.6%
T	53707	3.4%
Other values (71)	590049	36.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1597096	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	160059	10.0%
A	135262	8.5%
N	127057	8.0%
R	120499	7.5%
B	93985	5.9%
C	91654	5.7%
H	84757	5.3%
E	82327	5.2%
O	57740	3.6%
T	53707	3.4%
Other values (71)	590049	36.9%

OFFNUM
Real number (ℝ)

High correlation Zeros

Distinct	9708
Distinct (%)	12.2%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1410.45

Minimum	0
Maximum	10535
Zeros	4577
Zeros (%)	5.8%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11
median	143
Q3	1616
95-th percentile	7774
Maximum	10535
Range	10535
Interquartile range (IQR)	1605

Descriptive statistics

Standard deviation	2442.1824
Coefficient of variation (CV)	1.7314917
Kurtosis	3.0629177
Mean	1410.45
Median Absolute Deviation (MAD)	142
Skewness	2.0075251
Sum	1.121886 × 10⁸
Variance	5964254.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4577	5.8%
1	2512	3.2%
2	2319	2.9%
3	1959	2.5%
4	1689	2.1%
5	1471	1.8%
6	1282	1.6%
7	1123	1.4%
8	998	1.3%
9	897	1.1%
Other values (9698)	60714	76.3%

Value	Count	Frequency (%)
0	4577	5.8%
1	2512	3.2%
2	2319	2.9%
3	1959	2.5%
4	1689	2.1%
5	1471	1.8%
6	1282	1.6%
7	1123	1.4%
8	998	1.3%
9	897	1.1%

Value	Count	Frequency (%)
10535	1	< 0.1%
10534	1	< 0.1%
10533	1	< 0.1%
10532	1	< 0.1%
10531	1	< 0.1%
10530	1	< 0.1%
10529	1	< 0.1%
10528	1	< 0.1%
10527	1	< 0.1%
10526	1	< 0.1%

RUNDATE
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	621.6 KiB

45401.0	79541

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	556787
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	45401.0
2nd row	45401.0
3rd row	45401.0
4th row	45401.0
5th row	45401.0

Common Values

Value	Count	Frequency (%)
45401.0	79541	> 99.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
45401.0	79541	100.0%

Most occurring characters

Value	Count	Frequency (%)
4	159082	28.6%
0	159082	28.6%
5	79541	14.3%
1	79541	14.3%
.	79541	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	556787	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	159082	28.6%
0	159082	28.6%
5	79541	14.3%
1	79541	14.3%
.	79541	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	556787	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	159082	28.6%
0	159082	28.6%
5	79541	14.3%
1	79541	14.3%
.	79541	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	556787	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	159082	28.6%
0	159082	28.6%
5	79541	14.3%
1	79541	14.3%
.	79541	14.3%

SERVTYPE
Real number (ℝ)

High correlation

Distinct	14
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	11.734791

Minimum	11
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	11
5-th percentile	11
Q1	11
median	11
Q3	11
95-th percentile	13
Maximum	99
Range	88
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.6552091
Coefficient of variation (CV)	0.31148481
Kurtosis	210.17446
Mean	11.734791
Median Absolute Deviation (MAD)	0
Skewness	10.826712
Sum	933397
Variance	13.360553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
11	72967	91.7%
12	2575	3.2%
23	1537	1.9%
24	892	1.1%
29	359	0.5%
27	310	0.4%
21	249	0.3%
30	178	0.2%
13	177	0.2%
26	154	0.2%
Other values (4)	143	0.2%

Value	Count	Frequency (%)
11	72967	91.7%
12	2575	3.2%
13	177	0.2%
21	249	0.3%
22	4	< 0.1%
23	1537	1.9%
24	892	1.1%
25	28	< 0.1%
26	154	0.2%
27	310	0.4%

Value	Count	Frequency (%)
99	50	0.1%
30	178	0.2%
29	359	0.5%
28	61	0.1%
27	310	0.4%
26	154	0.2%
25	28	< 0.1%
24	892	1.1%
23	1537	1.9%
22	4	< 0.1%

SERVTYPE_DESC
Categorical

High correlation Imbalance

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	621.6 KiB

FULL SERVICE - BRICK AND MORTAR	72967
FULL SERVICE - RETAIL	2575
LIMITED SERVICE - DRIVE THRU/DETACHED FACILITY	1537
LIMITED SERVICE - LOAN PRODUCTION	892
LIMITED SERVICE - MOBILE/SEASONAL	359
Other values (10)	1212

Length

Max length	46
Median length	31
Mean length	30.953521
Min length	13

Characters and Unicode

Total characters	2462105
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	FULL SERVICE - BRICK AND MORTAR
2nd row	FULL SERVICE - BRICK AND MORTAR
3rd row	FULL SERVICE - BRICK AND MORTAR
4th row	FULL SERVICE - BRICK AND MORTAR
5th row	FULL SERVICE - BRICK AND MORTAR

Common Values

Value	Count	Frequency (%)
FULL SERVICE - BRICK AND MORTAR	72967	91.7%
FULL SERVICE - RETAIL	2575	3.2%
LIMITED SERVICE - DRIVE THRU/DETACHED FACILITY	1537	1.9%
LIMITED SERVICE - LOAN PRODUCTION	892	1.1%
LIMITED SERVICE - MOBILE/SEASONAL	359	0.5%
LIMITED SERVICE - MESSENGER	310	0.4%
LIMITED SERVICE - ADMINISTRATIVE	249	0.3%
LIMITED SERVICE - TRUST	178	0.2%
FULL SERVICE - HOME BANKING	177	0.2%
LIMITED SERVICE - CONTRACTUAL	154	0.2%
Other values (5)	144	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
service	79541	17.0%
	79541	17.0%
full	75719	16.2%
brick	72967	15.6%
and	72967	15.6%
mortar	72967	15.6%
limited	3822	0.8%
retail	2636	0.6%
facility	1541	0.3%
drive	1537	0.3%
Other values (16)	5086	1.1%

Most occurring characters

Value	Count	Frequency (%)
	388782	15.8%
R	306096	12.4%
E	172384	7.0%
I	169668	6.9%
L	161205	6.5%
C	156943	6.4%
A	154295	6.3%
T	86177	3.5%
D	82570	3.4%
S	81336	3.3%
Other values (15)	702649	28.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2462105	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	388782	15.8%
R	306096	12.4%
E	172384	7.0%
I	169668	6.9%
L	161205	6.5%
C	156943	6.4%
A	154295	6.3%
T	86177	3.5%
D	82570	3.4%
S	81336	3.3%
Other values (15)	702649	28.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2462105	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	388782	15.8%
R	306096	12.4%
E	172384	7.0%
I	169668	6.9%
L	161205	6.5%
C	156943	6.4%
A	154295	6.3%
T	86177	3.5%
D	82570	3.4%
S	81336	3.3%
Other values (15)	702649	28.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2462105	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	388782	15.8%
R	306096	12.4%
E	172384	7.0%
I	169668	6.9%
L	161205	6.5%
C	156943	6.4%
A	154295	6.3%
T	86177	3.5%
D	82570	3.4%
S	81336	3.3%
Other values (15)	702649	28.5%

STALP
Text

Missing

Distinct	59
Distinct (%)	0.1%
Missing	803
Missing (%)	1.0%
Memory size	621.6 KiB

Length

Max length	5
Median length	2
Mean length	2.0000381
Min length	2

Characters and Unicode

Total characters	157481
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	MO

Value	Count	Frequency (%)
tx	6359	8.1%
ca	5770	7.3%
fl	4349	5.5%
ny	4151	5.3%
il	3721	4.7%
pa	3473	4.4%
oh	3127	4.0%
nj	2350	3.0%
mi	2177	2.8%
mo	2153	2.7%
Other values (49)	41109	52.2%

Most occurring characters

Value	Count	Frequency (%)
A	23243	14.8%
N	16661	10.6%
I	11738	7.5%
C	11560	7.3%
M	11436	7.3%
L	10823	6.9%
T	10498	6.7%
O	8743	5.6%
X	6359	4.0%
Y	5881	3.7%
Other values (14)	40539	25.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	157481	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	23243	14.8%
N	16661	10.6%
I	11738	7.5%
C	11560	7.3%
M	11436	7.3%
L	10823	6.9%
T	10498	6.7%
O	8743	5.6%
X	6359	4.0%
Y	5881	3.7%
Other values (14)	40539	25.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	157481	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	23243	14.8%
N	16661	10.6%
I	11738	7.5%
C	11560	7.3%
M	11436	7.3%
L	10823	6.9%
T	10498	6.7%
O	8743	5.6%
X	6359	4.0%
Y	5881	3.7%
Other values (14)	40539	25.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	157481	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	23243	14.8%
N	16661	10.6%
I	11738	7.5%
C	11560	7.3%
M	11436	7.3%
L	10823	6.9%
T	10498	6.7%
O	8743	5.6%
X	6359	4.0%
Y	5881	3.7%
Other values (14)	40539	25.7%

STCNTY
Real number (ℝ)

High correlation Zeros

Distinct	3198
Distinct (%)	4.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	28538.94

Minimum	0
Maximum	78030
Zeros	803
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	5085
Q1	16001
median	28115
Q3	42017
95-th percentile	53031
Maximum	78030
Range	78030
Interquartile range (IQR)	26016

Descriptive statistics

Standard deviation	15864.222
Coefficient of variation (CV)	0.55587988
Kurtosis	-1.0749524
Mean	28538.94
Median Absolute Deviation (MAD)	13894
Skewness	0.0097804197
Sum	2.2700158 × 10⁹
Variance	2.5167355 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6037	1466	1.8%
17031	1155	1.5%
48201	885	1.1%
0	803	1.0%
4013	666	0.8%
48113	597	0.8%
12086	581	0.7%
6059	557	0.7%
36061	551	0.7%
6073	469	0.6%
Other values (3188)	71811	90.3%

Value	Count	Frequency (%)
0	803	1.0%
1001	15	< 0.1%
1003	89	0.1%
1005	10	< 0.1%
1007	7	< 0.1%
1009	14	< 0.1%
1011	2	< 0.1%
1013	9	< 0.1%
1015	29	< 0.1%
1017	7	< 0.1%

Value	Count	Frequency (%)
78030	9	< 0.1%
78020	2	< 0.1%
78010	9	< 0.1%
72153	4	< 0.1%
72151	2	< 0.1%
72149	1	< 0.1%
72147	1	< 0.1%
72145	3	< 0.1%
72143	1	< 0.1%
72141	1	< 0.1%

STNAME
Text

Missing

Distinct	59
Distinct (%)	0.1%
Missing	803
Missing (%)	1.0%
Memory size	621.6 KiB

Length

Max length	30
Median length	24
Mean length	8.3739697
Min length	4

Characters and Unicode

Total characters	659358
Distinct characters	48
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Illinois
2nd row	Illinois
3rd row	Illinois
4th row	Illinois
5th row	Missouri

Value	Count	Frequency (%)
new	7309	8.0%
texas	6359	6.9%
california	5770	6.3%
florida	4349	4.7%
york	4151	4.5%
illinois	3721	4.1%
pennsylvania	3473	3.8%
carolina	3216	3.5%
ohio	3127	3.4%
north	2456	2.7%
Other values (60)	47765	52.1%

Most occurring characters

Value	Count	Frequency (%)
a	82914	12.6%
i	71373	10.8%
n	57355	8.7%
s	52334	7.9%
o	51967	7.9%
e	43409	6.6%
r	37085	5.6%
l	30365	4.6%
t	17740	2.7%
h	15700	2.4%
Other values (38)	199116	30.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	659358	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	82914	12.6%
i	71373	10.8%
n	57355	8.7%
s	52334	7.9%
o	51967	7.9%
e	43409	6.6%
r	37085	5.6%
l	30365	4.6%
t	17740	2.7%
h	15700	2.4%
Other values (38)	199116	30.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	659358	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	82914	12.6%
i	71373	10.8%
n	57355	8.7%
s	52334	7.9%
o	51967	7.9%
e	43409	6.6%
r	37085	5.6%
l	30365	4.6%
t	17740	2.7%
h	15700	2.4%
Other values (38)	199116	30.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	659358	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	82914	12.6%
i	71373	10.8%
n	57355	8.7%
s	52334	7.9%
o	51967	7.9%
e	43409	6.6%
r	37085	5.6%
l	30365	4.6%
t	17740	2.7%
h	15700	2.4%
Other values (38)	199116	30.2%

UNINUM
Real number (ℝ)

High correlation

Distinct	79541
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	305329.74

Minimum	3
Maximum	663907
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	3
5-th percentile	6214
Q1	198678
median	263437
Q3	464262
95-th percentile	627297
Maximum	663907
Range	663904
Interquartile range (IQR)	265584

Descriptive statistics

Standard deviation	191723.6
Coefficient of variation (CV)	0.62792309
Kurtosis	-0.95377428
Mean	305329.74
Median Absolute Deviation (MAD)	168927
Skewness	0.08674046
Sum	2.4286233 × 10¹⁰
Variance	3.6757937 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
629595	1	< 0.1%
223055	1	< 0.1%
232078	1	< 0.1%
466427	1	< 0.1%
9231	1	< 0.1%
429739	1	< 0.1%
641411	1	< 0.1%
641392	1	< 0.1%
632193	1	< 0.1%
621883	1	< 0.1%
Other values (79531)	79531	> 99.9%

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%

Value	Count	Frequency (%)
663907	1	< 0.1%
663906	1	< 0.1%
663905	1	< 0.1%
663904	1	< 0.1%
663898	1	< 0.1%
663897	1	< 0.1%
663896	1	< 0.1%
663886	1	< 0.1%
663885	1	< 0.1%
663876	1	< 0.1%

ZIP
Real number (ℝ)

High correlation

Distinct	18284
Distinct (%)	23.0%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	48949.246

Minimum	0
Maximum	99929
Zeros	794
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	621.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4602.3
Q1	27540
median	47715
Q3	73529
95-th percentile	94591
Maximum	99929
Range	99929
Interquartile range (IQR)	45989

Descriptive statistics

Standard deviation	28237.231
Coefficient of variation (CV)	0.57686753
Kurtosis	-1.1186076
Mean	48949.246
Median Absolute Deviation (MAD)	24111
Skewness	0.041589
Sum	3.8933741 × 10⁹
Variance	7.9734121 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	794	1.0%
10022	56	0.1%
33134	47	0.1%
75225	46	0.1%
85016	43	0.1%
33131	43	0.1%
72401	41	0.1%
37027	41	0.1%
17601	40	0.1%
76107	40	0.1%
Other values (18274)	78348	98.5%

Value	Count	Frequency (%)
0	794	1.0%
100	1	< 0.1%
601	1	< 0.1%
602	2	< 0.1%
603	4	< 0.1%
604	1	< 0.1%
606	1	< 0.1%
610	1	< 0.1%
612	5	< 0.1%
617	2	< 0.1%

Value	Count	Frequency (%)
99929	2	< 0.1%
99921	2	< 0.1%
99901	6	< 0.1%
99840	1	< 0.1%
99835	4	< 0.1%
99833	2	< 0.1%
99827	1	< 0.1%
99801	9	< 0.1%
99780	1	< 0.1%
99762	2	< 0.1%

Interactions

Correlations

	ACQDATE	BKCLASS	CBSA_DIV	CBSA_DIV_FLG	CBSA_DIV_NO	CBSA_METRO	CBSA_METRO_FLG	CBSA_MICRO_FLG	CBSA_NO	CERT	CSA_FLG	CSA_NO	FI_UNINUM	ID	LATITUDE	LONGITUDE	MAINOFF	MDI_STATUS_DESC	OBJECTID	OFFNUM	SERVTYPE	SERVTYPE_DESC	STCNTY	UNINUM	X	Y	ZIP
ACQDATE	1.000	0.160	0.185	0.132	0.018	0.003	0.106	0.081	-0.006	0.200	0.076	-0.011	0.202	0.326	-0.117	0.008	1.000	0.281	0.019	0.012	0.044	0.071	-0.035	0.326	0.008	-0.117	0.018
BKCLASS	0.160	1.000	0.410	0.191	0.120	0.085	0.115	0.115	0.075	0.309	0.114	0.096	0.061	0.097	0.058	0.062	0.179	0.478	0.152	0.221	0.048	0.384	0.100	0.097	0.062	0.058	0.158
CBSA_DIV	0.185	0.410	1.000	1.000	0.999	0.999	1.000	1.000	0.999	0.221	1.000	0.999	0.103	0.138	0.764	0.607	0.077	0.459	0.168	0.192	0.099	0.298	0.904	0.138	0.607	0.764	0.927
CBSA_DIV_FLG	0.132	0.191	1.000	1.000	1.000	0.513	0.359	0.162	0.463	0.127	0.391	0.507	0.079	0.095	0.090	0.178	0.057	0.225	0.107	0.166	0.041	0.051	0.324	0.095	0.178	0.090	0.371
CBSA_DIV_NO	0.018	0.120	0.999	1.000	1.000	0.973	1.000	1.000	0.973	0.026	1.000	0.973	0.025	0.160	0.271	0.415	0.104	0.300	0.030	0.253	-0.026	0.046	0.535	0.160	0.415	0.271	-0.422
CBSA_METRO	0.003	0.085	0.999	0.513	0.973	1.000	1.000	0.452	0.821	0.035	0.712	0.839	0.033	0.125	0.067	0.273	0.092	0.285	0.029	0.155	-0.014	0.057	0.356	0.125	0.273	0.067	-0.275
CBSA_METRO_FLG	0.106	0.115	1.000	0.359	1.000	1.000	1.000	0.452	0.792	0.086	0.694	0.872	0.057	0.163	0.139	0.356	0.090	0.454	0.058	0.143	0.038	0.061	0.541	0.163	0.356	0.139	0.387
CBSA_MICRO_FLG	0.081	0.115	1.000	0.162	1.000	0.452	0.452	1.000	0.246	0.079	0.059	0.207	0.037	0.115	0.101	0.049	0.067	0.288	0.104	0.149	0.042	0.065	0.180	0.115	0.049	0.101	0.159
CBSA_NO	-0.006	0.075	0.999	0.463	0.973	0.821	0.792	0.246	1.000	0.058	0.739	0.905	0.057	0.066	0.104	0.252	0.063	0.287	0.035	0.052	-0.001	0.044	0.414	0.066	0.252	0.104	-0.262
CERT	0.200	0.309	0.221	0.127	0.026	0.035	0.086	0.079	0.058	1.000	0.068	0.029	0.999	0.130	0.080	0.094	0.113	0.430	-0.048	-0.440	0.052	0.082	0.086	0.130	0.094	0.080	-0.093
CSA_FLG	0.076	0.114	1.000	0.391	1.000	0.712	0.694	0.059	0.739	0.068	1.000	1.000	0.043	0.122	0.070	0.345	0.069	0.405	0.066	0.113	0.026	0.045	0.511	0.122	0.345	0.070	0.377
CSA_NO	-0.011	0.096	0.999	0.507	0.973	0.839	0.872	0.207	0.905	0.029	1.000	1.000	0.030	0.088	0.123	0.279	0.072	0.340	0.051	0.105	-0.002	0.065	0.472	0.088	0.279	0.123	-0.267
FI_UNINUM	0.202	0.061	0.103	0.079	0.025	0.033	0.057	0.037	0.057	0.999	0.043	0.030	1.000	0.129	0.077	0.090	0.110	0.396	-0.048	-0.438	0.052	0.031	0.087	0.129	0.090	0.077	-0.088
ID	0.326	0.097	0.138	0.095	0.160	0.125	0.163	0.115	0.066	0.130	0.122	0.088	0.129	1.000	-0.138	0.056	0.468	0.141	-0.002	0.112	0.168	0.103	-0.009	1.000	0.056	-0.138	-0.001
LATITUDE	-0.117	0.058	0.764	0.090	0.271	0.067	0.139	0.101	0.104	0.080	0.070	0.123	0.077	-0.138	1.000	-0.070	0.076	0.340	0.005	-0.101	-0.024	0.057	0.196	-0.138	-0.070	1.000	-0.136
LONGITUDE	0.008	0.062	0.607	0.178	0.415	0.273	0.356	0.049	0.252	0.094	0.345	0.279	0.090	0.056	-0.070	1.000	0.080	0.382	-0.018	0.047	-0.019	0.080	0.088	0.056	1.000	-0.070	-0.838
MAINOFF	1.000	0.179	0.077	0.057	0.104	0.092	0.090	0.067	0.063	0.113	0.069	0.072	0.110	0.468	0.076	0.080	1.000	0.268	0.097	0.161	0.055	0.073	0.099	0.468	0.080	0.076	0.141
MDI_STATUS_DESC	0.281	0.478	0.459	0.225	0.300	0.285	0.454	0.288	0.287	0.430	0.405	0.340	0.396	0.141	0.340	0.382	0.268	1.000	0.292	1.000	0.156	0.374	0.398	0.141	0.382	0.340	0.356
OBJECTID	0.019	0.152	0.168	0.107	0.030	0.029	0.058	0.104	0.035	-0.048	0.066	0.051	-0.048	-0.002	0.005	-0.018	0.097	0.292	1.000	0.135	0.035	0.075	0.043	-0.002	-0.018	0.005	-0.002
OFFNUM	0.012	0.221	0.192	0.166	0.253	0.155	0.143	0.149	0.052	-0.440	0.113	0.105	-0.438	0.112	-0.101	0.047	0.161	1.000	0.135	1.000	-0.023	0.057	-0.087	0.112	0.047	-0.101	-0.044
SERVTYPE	0.044	0.048	0.099	0.041	-0.026	-0.014	0.038	0.042	-0.001	0.052	0.026	-0.002	0.052	0.168	-0.024	-0.019	0.055	0.156	0.035	-0.023	1.000	1.000	0.028	0.168	-0.019	-0.024	0.039
SERVTYPE_DESC	0.071	0.384	0.298	0.051	0.046	0.057	0.061	0.065	0.044	0.082	0.045	0.065	0.031	0.103	0.057	0.080	0.073	0.374	0.075	0.057	1.000	1.000	0.073	0.103	0.080	0.057	0.059
STCNTY	-0.035	0.100	0.904	0.324	0.535	0.356	0.541	0.180	0.414	0.086	0.511	0.472	0.087	-0.009	0.196	0.088	0.099	0.398	0.043	-0.087	0.028	0.073	1.000	-0.009	0.088	0.196	-0.101
UNINUM	0.326	0.097	0.138	0.095	0.160	0.125	0.163	0.115	0.066	0.130	0.122	0.088	0.129	1.000	-0.138	0.056	0.468	0.141	-0.002	0.112	0.168	0.103	-0.009	1.000	0.056	-0.138	-0.001
X	0.008	0.062	0.607	0.178	0.415	0.273	0.356	0.049	0.252	0.094	0.345	0.279	0.090	0.056	-0.070	1.000	0.080	0.382	-0.018	0.047	-0.019	0.080	0.088	0.056	1.000	-0.070	-0.838
Y	-0.117	0.058	0.764	0.090	0.271	0.067	0.139	0.101	0.104	0.080	0.070	0.123	0.077	-0.138	1.000	-0.070	0.076	0.340	0.005	-0.101	-0.024	0.057	0.196	-0.138	-0.070	1.000	-0.136
ZIP	0.018	0.158	0.927	0.371	-0.422	-0.275	0.387	0.159	-0.262	-0.093	0.377	-0.267	-0.088	-0.001	-0.136	-0.838	0.141	0.356	-0.002	-0.044	0.039	0.059	-0.101	-0.001	-0.838	-0.136	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	X	Y	OBJECTID	ACQDATE	ADDRESS	ADDRESS2	BKCLASS	CBSA	CBSA_DIV	CBSA_DIV_NO	CBSA_METRO	CBSA_METRO_FLG	CBSA_METRO_NAME	CBSA_NO	CERT	CITY	COUNTY	CSA	CSA_FLG	CSA_NO	ESTYMD	FI_UNINUM	ID	LATITUDE	LONGITUDE	MAINOFF	MDI_STATUS_CODE	MDI_STATUS_DESC	NAME	OFFNAME	OFFNUM	RUNDATE	SERVTYPE	SERVTYPE_DESC	STALP	STCNTY	STNAME	UNINUM	ZIP
0	-89.554910	38.684286	1	42539.0	18001 Saint Rose Rd	NaN	SM	St. Louis, MO-IL	NaN	NaN	41180.0	1.0	St. Louis, MO-IL	41180.0	14761.0	Breese	Clinton	St. Louis-St. Charles-Farmington, MO-IL	1.0	476.0	30964	9231.0	223055.0	38.684286	-89.554910	0.0	NaN	NaN	1NB Bank	ST. ROSE FACILITY BRANCH	3.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	IL	17027.0	Illinois	223055.0	62230.0
1	-89.372215	38.618182	2	NaN	1350 12th St	NaN	SM	St. Louis, MO-IL	NaN	NaN	41180.0	1.0	St. Louis, MO-IL	41180.0	14761.0	Carlyle	Clinton	St. Louis-St. Charles-Farmington, MO-IL	1.0	476.0	25373	9231.0	232078.0	38.618182	-89.372215	0.0	NaN	NaN	1NB Bank	1350 12TH STREET FACILITY	1.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	IL	17027.0	Illinois	232078.0	62231.0
2	-89.612338	38.611731	3	NaN	500 W Harrison St	NaN	SM	St. Louis, MO-IL	NaN	NaN	41180.0	1.0	St. Louis, MO-IL	41180.0	14761.0	Aviston	Clinton	St. Louis-St. Charles-Farmington, MO-IL	1.0	476.0	39104	9231.0	466427.0	38.611731	-89.612338	0.0	NaN	NaN	1NB Bank	AVISTON BRANCH	2.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	IL	17027.0	Illinois	466427.0	62216.0
3	-89.369023	38.611248	4	NaN	891 Fairfax St	NaN	SM	St. Louis, MO-IL	NaN	NaN	41180.0	1.0	St. Louis, MO-IL	41180.0	14761.0	Carlyle	Clinton	St. Louis-St. Charles-Farmington, MO-IL	1.0	476.0	01/01/1878	9231.0	9231.0	38.611248	-89.369023	1.0	NaN	NaN	1NB Bank	1NB Bank	0.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	IL	17027.0	Illinois	9231.0	62231.0
4	-90.655980	38.797082	5	NaN	240 Salt Lick Rd	NaN	NM	St. Louis, MO-IL	NaN	NaN	41180.0	1.0	St. Louis, MO-IL	41180.0	57899.0	Saint Peters	St. Charles	St. Louis-St. Charles-Farmington, MO-IL	1.0	476.0	38383	429739.0	429739.0	38.797082	-90.655980	1.0	NaN	NaN	1st Advantage Bank	1st Advantage Bank	0.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	MO	29183.0	Missouri	429739.0	63376.0
5	-114.770516	32.489945	6	40960.0	645 N William Brooks Ave	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	57298.0	San Luis	Yuma	NaN	0.0	0.0	35216	360755.0	251437.0	32.489945	-114.770516	0.0	NaN	NaN	1st Bank Yuma	SAN LUIS BRANCH	4.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	AZ	4027.0	Arizona	251437.0	85336.0
6	-114.624469	32.676737	7	NaN	2799 S 4th Ave	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	57298.0	Yuma	Yuma	NaN	0.0	0.0	37138	360755.0	360755.0	32.676737	-114.624469	1.0	NaN	NaN	1st Bank Yuma	1st Bank Yuma	0.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	AZ	4027.0	Arizona	360755.0	85364.0
7	-114.624789	32.694539	8	42251.0	1800 S 4th Ave	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	57298.0	Yuma	Yuma	NaN	0.0	0.0	39329	360755.0	467596.0	32.694539	-114.624789	0.0	NaN	NaN	1st Bank Yuma	YUMA BRANCH	5.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	AZ	4027.0	Arizona	467596.0	85364.0
8	-110.931017	31.347570	9	42223.0	825 N Grand Ave	Ste 104	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	57298.0	Nogales	Santa Cruz	NaN	0.0	0.0	39352	360755.0	468263.0	31.347570	-110.931017	0.0	NaN	NaN	1st Bank Yuma	NOGALES BRANCH	6.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	AZ	4023.0	Arizona	468263.0	85621.0
9	-114.444178	32.660442	10	NaN	11600 S Fortuna Rd	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	57298.0	Yuma	Yuma	NaN	0.0	0.0	39790	360755.0	493457.0	32.660442	-114.444178	0.0	NaN	NaN	1st Bank Yuma	Fortuna Branch	3.0	45401.0	13.0	FULL SERVICE - HOME BANKING	AZ	4027.0	Arizona	493457.0	85367.0

	X	Y	OBJECTID	ACQDATE	ADDRESS	ADDRESS2	BKCLASS	CBSA	CBSA_DIV	CBSA_DIV_NO	CBSA_METRO	CBSA_METRO_FLG	CBSA_METRO_NAME	CBSA_MICRO_FLG	CBSA_NO	CERT	CITY	COUNTY	CSA	CSA_FLG	CSA_NO	ESTYMD	FI_UNINUM	ID	LATITUDE	LONGITUDE	MAINOFF	MDI_STATUS_CODE	MDI_STATUS_DESC	NAME	OFFNAME	OFFNUM	RUNDATE	SERVTYPE	SERVTYPE_DESC	STALP	STCNTY	STNAME	UNINUM	ZIP
79532	0.000000	0.000000	79533	43952.0	301 N Pine St	NaN	NM	DeRidder, LA	NaN	NaN	0.0	0.0	NaN	1.0	19760.0	58228.0	Deridder	Beauregard	DeRidder-Fort Polk South, LA	1.0	217.0	05/28/1928	443550.0	6747.0	0.000000	0.000000	0.0	NaN	NaN	b1BANK	Deridder Banking Cener Branch	71.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	LA	22011.0	Louisiana	6747.0	70634.0
79533	0.000000	0.000000	79534	NaN	1300 W Tunnel Blvd	NaN	NM	Houma-Thibodaux, LA	NaN	NaN	26380.0	1.0	Houma-Thibodaux, LA	0.0	26380.0	58228.0	Houma	Terrebonne	NaN	0.0	NaN	05/01/2020	443550.0	73828.0	0.000000	0.000000	0.0	NaN	NaN	b1BANK	Houma - W Tunnel Blvd Banking Center Branch	79.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	LA	22109.0	Louisiana	73828.0	70360.0
79534	-116.792632	47.681198	79535	NaN	912 Northwest Blvd	NaN	NM	Coeur d'Alene, ID	NaN	NaN	17660.0	1.0	Coeur d'Alene, ID	0.0	17660.0	57074.0	Coeur D Alene	Kootenai	Spokane-Spokane Valley-Coeur d'Alene, WA-ID	1.0	518.0	05/17/2001	356862.0	356862.0	47.681198	-116.792632	1.0	NaN	NaN	bankcda	bankcda	0.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	ID	16055.0	Idaho	356862.0	83814.0
79535	-116.124442	47.537693	79536	41509.0	120 Railroad Ave	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	0.0	57074.0	Kellogg	Shoshone	NaN	0.0	0.0	09/18/2000	356862.0	360910.0	47.537693	-116.124442	0.0	NaN	NaN	bankcda	Kellogg Branch	4.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	ID	16079.0	Idaho	360910.0	83837.0
79536	-116.788501	47.758750	79537	NaN	162 W Hayden Ave	NaN	NM	Coeur d'Alene, ID	NaN	NaN	17660.0	1.0	Coeur d'Alene, ID	0.0	17660.0	57074.0	Hayden	Kootenai	Spokane-Spokane Valley-Coeur d'Alene, WA-ID	1.0	518.0	04/13/2015	356862.0	567663.0	47.758750	-116.788501	0.0	NaN	NaN	bankcda	Hayden Branch	5.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	ID	16055.0	Idaho	567663.0	83835.0
79537	-116.935850	47.714039	79538	NaN	922 E Polston Ave	NaN	NM	Coeur d'Alene, ID	NaN	NaN	17660.0	1.0	Coeur d'Alene, ID	0.0	17660.0	57074.0	Post Falls	Kootenai	Spokane-Spokane Valley-Coeur d'Alene, WA-ID	1.0	518.0	09/10/2019	356862.0	616993.0	47.714039	-116.935850	0.0	NaN	NaN	bankcda	Post Falls Branch	6.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	ID	16055.0	Idaho	616993.0	83854.0
79538	0.000000	0.000000	79539	NaN	120 Railroad Ave	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	0.0	57074.0	Kellogg	Shoshone	NaN	0.0	0.0	03/21/2022	356862.0	651678.0	0.000000	0.000000	0.0	NaN	NaN	bankcda	Messenger Service Branch	7.0	45401.0	27.0	LIMITED SERVICE - MESSENGER	ID	16079.0	Idaho	651678.0	83837.0
79539	-92.952975	40.266955	79540	NaN	1 S Lincoln St	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	0.0	16103.0	Green City	Sullivan	NaN	0.0	0.0	11/21/1943	10320.0	10320.0	40.266955	-92.952975	1.0	NaN	NaN	farmbank	farmbank	0.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	MO	29211.0	Missouri	10320.0	63545.0
79540	0.000000	0.000000	79541	NaN	701 N Pearl St	NaN	NM	NaN	NaN	0.0	0.0	0.0	NaN	0.0	0.0	16103.0	Milan	Sullivan	NaN	0.0	0.0	09/17/2007	10320.0	468331.0	0.000000	0.000000	0.0	NaN	NaN	farmbank	Milan Branch	2.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	MO	29211.0	Missouri	468331.0	63556.0
79541	-92.583356	40.228715	79542	NaN	3311 N Baltimore St	NaN	NM	Kirksville, MO	NaN	NaN	0.0	0.0	NaN	1.0	28860.0	16103.0	Kirksville	Adair	NaN	0.0	NaN	12/16/2020	10320.0	629595.0	40.228715	-92.583356	0.0	NaN	NaN	farmbank	Kirksville Branch	3.0	45401.0	11.0	FULL SERVICE - BRICK AND MORTAR	MO	29001.0	Missouri	629595.0	63501.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)